
<?php
session_start();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-Transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
    <head>
        <title>Rotaract DLSU</title>
        <meta http-equiv="Content-Type" content="text/html"/>
        <meta name="robots" content="index,follow"/>
        <meta name="distribution" content="global"/>
        <meta name="description" content=""/>
        <meta name="keywords" content=""/>
        <link href="css/style.css" rel="stylesheet" type="text/css" media="screen" />
    </head>
    <body>

        <div id="container2">
            <div id="main3">
                <table width="100%" cellspacing="0" cellpadding="0">
                    <tr>
                        <td class="main_nav">
                            <div id="main_text2"> 
                                <center>
                                    <h2>List of Agenda</h2>
                                    <?
                                    include 'DBLibrary/config.php';
                                    include 'DBLibrary/openDB.php';

                                    mysql_select_db("rotaract");
                                    $query = "SELECT * FROM agenda order by date asc ";
                                    $result = mysql_query($query) or die(mysql_error());
                                    ?><table cellpadding="10" class="myTable">
                                        <tr>
                                            <td><b>Date of Agenda</b></td>
                                            <td><b>Place of Agenda</b></td>
                                            <td><b>Description</b></td>
                                            <td><b>Start Time</b></td>
                                            <td><b>End Time</b></td>
                                        </tr>
                                        <br/>
                                        <br/>
                                        <?
                                        while ($row = mysql_fetch_array($result)) {
                                            $dateAgenda = $row['date'];
                                            $placeAgenda = $row['place'];
                                            $descAgenda = $row['desc'];
                                            $sTimeAgenda = $row['sTimeAgenda'];
                                            $eTimeAgenda = $row['eTimeAgenda'];

                                            echo ' <tr>';
                                            echo '     <td>' . $dateAgenda . '</td>';
                                            echo '     <td>' . $placeAgenda . '</td>';
                                            echo '     <td>' . $descAgenda . '</td>';
                                            echo '     <td>' . $sTimeAgenda . '</td>';
                                            echo '     <td>' . $eTimeAgenda . '</td>';
                                            echo '</tr>';
                                        }
                                        ?>
                                    </table>
                                </center>
                            </div>
                        </td>

                    </tr>
                </table>
            </div>
        </div>
    </body>
</html>